
module.exports = {
  DB_TABLES_SQL: ` select TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH, TABLE_COMMENT `
  + ` from information_schema.TABLES `
  + ` where TABLE_SCHEMA=(select database()) `,
  DB_TABLES_COLUMNS: (tableName) => ` select COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMN_TYPE, COLUMN_KEY, COLUMN_COMMENT `
  + ` from information_schema.COLUMNS `
  + ` where TABLE_SCHEMA = (select database()) `
  + ` and TABLE_NAME="${tableName}" `
}